{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["REG","README","Claims"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"REG","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Desc","Code",null,"Option Buttons"]
["ACTIVE PATIENTS","REG000",null,0]
["Applied","REG001"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]

{"sheet":"README","index":1,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,8,1,9],[2,8,2,9],[23,1,24,11],[14,13,17,19],[4,7,4,11],[5,7,5,11],[7,5,8,5],[7,11,8,11],[9,11,10,11],[9,5,10,5],[4,1,4,2],[5,1,5,2],[8,1,8,2],[9,1,9,2],[4,3,4,4],[32,13,33,19],[5,3,5,4],[8,9,8,10],[9,9,9,10],[7,7,7,10],[8,3,8,4],[9,3,9,4],[7,1,7,4],[8,7,8,8],[9,7,9,8]]}
[]
[null,"Northern Ireland Influenza Claims",null,null,null,null,null,null,"Reference Date",null,null,null,null,"NOTE:"]
[null,"Last updated: 13/06/2019 v2.3",null,null,null,null,null,null,"2019-03-31",null,null,null,null,"This will only work if Vision is on DLM485 or above."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed"]
[null,"Year Start Date",null,"Month Start",null,"Month End",null,"SELECT Registration Status"]
[null,"2019-09-01",null,"2019-05-01",null,"2019-05-31",null,"INCLUDE ALL",null,null,null,null,null,"Excel 2007 - Click the Options button and Enable both Macros and Data Connection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel 2003 - Not Supported"]
[null,"Enter Pre-School Age",null,null,null,"Calc Age From",null,"Enter Primary School DOB",null,null,null,"Calc Age From"]
[null,"Start DOB (>=)",null,"End DOB (<=)",null,null,null,"Start DOB (>=)",null,"End DOB (<=)",null,null,null,"Written by: Bradley Sieve"]
[null,"2017-09-01",null,"2015-07-02",null,"2019-09-01",null,"2015-07-01",null,"2008-07-02",null,"2019-09-01"]
[null,"Age:",{"$f":"IF(MONTH($F$10)>MONTH(B$10),YEAR($F$10)-YEAR(B$10),IF(AND(MONTH($F$10)=MONTH(B$10),DAY($F$10)>=DAY(B$10)),YEAR($F$10)-YEAR(B$10),(YEAR($F$10)-YEAR(B$10))-1))","v":2},"Age:",{"$f":"IF(MONTH($F$10)>MONTH(D$10),YEAR($F$10)-YEAR(D$10),IF(AND(MONTH($F$10)=MONTH(D$10),DAY($F$10)>=DAY(D$10)),YEAR($F$10)-YEAR(D$10),(YEAR($F$10)-YEAR(D$10))-1))","v":4},null,null,"Age:",{"$f":"IF(MONTH($L$10)>MONTH(H$10),YEAR($L$10)-YEAR(H$10),IF(AND(MONTH($L$10)=MONTH(H$10),DAY($L$10)>=DAY(H$10)),YEAR($L$10)-YEAR(H$10),(YEAR($L$10)-YEAR(H$10))-1))","v":4},"Age:",{"$f":"IF(MONTH($L$10)>MONTH(J$10),YEAR($L$10)-YEAR(J$10),IF(AND(MONTH($L$10)=MONTH(J$10),DAY($L$10)>=DAY(J$10)),YEAR($L$10)-YEAR(J$10),(YEAR($L$10)-YEAR(J$10))-1))","v":11},null,null,"Smart Clinic is an approved alliance partner of Vision"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Disclaimer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision responsible for any actions you carry out based on these results."]
[null,"Search Criteria"]
[null,"● Immunisation Status = Given"]
[null,"● Immunisation Source = In this Practice"]
[null,"● All immunisation types = FLU or FLUSIN or FLUSIN1"]
[]
[null,"Important Information"]
[null,"Each immunisation has its own tab for evidence"]
[null,"Only immunisations given In Practice are reported on (i.e. no OHP's)"]
[null,"Duplicate immunisations will be automatically removed if given in the same date range and the earliest immunisation will be retained using the following rules:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"V1.1"]
[null,"● FLU uses the Patient identifier to find duplicates",null,null,null,null,null,null,null,null,null,null,null,"Now includes patient address details"]
[null,"● FLUSIN or FLUSIN1 uses the Patient identifier, Immstype and Stage to find duplicate records",null,null,null,null,null,null,null,null,null,null,null,"V2.0"]
[null,"The 5 individual yellow immunisation tabs search using Month Start/End date, age range and imm type",null,null,null,null,null,null,null,null,null,null,null,"Age calculated from DOB rather than Age for Primary and Pre-School"]
[null,"The ALLFLUYEAR and ALLINTRAYEAR tabs search using the Year Start Date and immunisation type",null,null,null,null,null,null,null,null,null,null,null,"v2.1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"\"Notes Kept at\" added to tables"]
[null,"Claims Sheet",null,null,null,null,null,null,null,null,null,null,null,"Reference date added for working out 65y age"]
[null,"If immunisation rows are deleted on any immunisation sheet, the counts will be automatically adjusted",null,null,null,null,null,null,null,null,null,null,null,"v2.2"]
[null," on the Claims sheet",null,null,null,null,null,null,null,null,null,null,null,"Fix: It was missing patients on claim form that were under 65 given Intranasal that are not either Pre or primary school ages."]
[null,"The yellow cells will have to be manually entered from the UNDER65 sheet Special Risk reason text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"v2.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fix: Formulas on claim sheet now cater for no data found"]

{"sheet":"Claims","index":2,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[[12,16,12,17],[30,11,30,15],[15,3,15,13],[2,1,2,14],[3,11,5,15],[6,11,6,14],[13,3,13,13],[14,3,14,13],[18,1,18,4],[18,5,18,6],[18,7,18,9],[19,1,19,4],[19,5,19,6],[19,7,19,9],[32,1,33,14],[34,1,34,14],[21,1,21,9],[23,1,23,15],[24,1,24,15],[25,1,25,14],[26,1,26,14],[29,1,29,15]]}
[null,null,null,null,null,null,null,null,null,null,null,"FORM DES FLU (ii)"]
[null,null,null,null,null,null,null,null,null,null,null,"Activity Period: "]
[null,"DATA ACTIVITY AND CLAIM FORM FOR INFLUENZA VACCINATION"]
[]
[null,null,null,null,null,null,null,null,null,null,"Practice Name:"]
[null,"No. of vaccines unused between"]
[null,"No. of nasal vaccines given between",null,null,null,null,null,null,null,null,"Practice Code:"]
[]
[null,"Complete this form for Influenza Vaccination by age and also by the major risk grouping for the under 65 years age bands."]
[null,"Please note it is not necessary to identify clinical disease at risk groupings in the over 65 population."]
[]
[null,"Age Groups",null,"Chronic Resp Disease (include Children admitted to Hospital with LRD)","Heart","Renal","Diabetes","Chronic Liver Disease","Immuno due to Disease or Treatment","Pregnant","Chronic Neuro Disease","Carers","Morbid obesity (class III obesity)\nBMI ≥ 40","Others with Clinical Indication","Homes","Totals"]
[null,"6 mths to 64 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(D13:O13)<>P13,\"DISEASE COUNT DOES NOT MATCH TOTAL\",\"\")","v":""}]
[null,"* Primary School Children"]
[null,"**Pre School Children aged 2 years or more"]
[null,"65 and over",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Totals                   ",{"$f":"SUM($C$14:$C$16)","v":0},{"$f":"SUM(D13:D16)","v":0},{"$f":"SUM(E13:E16)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($P$13:$P$16)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C17:O17)-P17","v":0}]
[null,"Description",null,null,null,"Number of vaccinations",null,"Amount claimed (£9.42 per vaccine including data collection fee)"]
[null,"Number of patients receiving influenza vaccination",null,null,null,{"$f":"P17","v":0},null,{"$f":"F20*9.42","v":0}]
[]
[null,"Remember: for patients under 65 years - count only one major risk grouping per patient"]
[]
[null,"NB Column \"Homes\" - Please record vaccines given to patients in long stay residential and nursing homes irrespective of whether any of them suffer from any of the at risk diseases."]
[null,"The \"others\" column should be used for patients not in the main risk groups but for when the GP decides there is a clinical reason for vaccination.  If the vaccine is given to any \"worried well\" they should not be included on this form and vaccines from the central stock should not be used to vaccinate them."]
[null,"* All Primary School children including those \"at risk\" should be included in the Primary School total and not reported under risk categories.  This figure should only include those Primary School children vaccinated by the Practice"]
[null,"** All Pre School Children (DOB range 02/07/2017 - 01/09/2017) including those 'at risk' should be included in the Pre School Children total and not reported under risk categories."]
[]
[null,"Practice Declaration"]
[null,"I confirm the practice has vaccinated the above number of patients in line with the NI service specification for the Directed Enhanced Service for Influenza vaccination"]
[null,"Practice Signature:________________________________________________",null,null,null,null,null,null,null,null,"Date: ",{"$f":"TODAY()","v":"2019-06-17"}]
[]
[null,"Electronic completed form should be submitted within 3 working days to gms.claims@hscni.net or 'hard copy' completed form should be submitted within 5 working days of the end of the month in which the activity was undertaken in order for payment to be made at the end of the following month:"]
[]
[null,"GP Payments,  BSO, 2 Franklin Street, Belfast BT2 8DQ"]
[]
[null,null,null,"Checked against signatory list?"]